SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:A special opportunity to acquire a dramatic contemporary on 10+/- gorgeous acres, featuring Trout Brook, a swimming hole, and a magnificent waterfall. Located in the gorgeous hills of Lyme the house was created by architect Don Metz, an early pioneer of thoughtful sustainable design. Living room has dramatic windows, hardwood floors and cozy stove. The kitchen and dining room look out to a large year round sunroom from which you can see Trout Brook. First floor also has two offices, both with lovely views. Upstairs there are three bedrooms, one with a loft, and two full baths. A further finished space in the walkout lower level has a guest room or playroom and bath. And then there is the guest house, which has a complete apartment which you can use for guests or as a rental. This is a really great listing!
Description:Welcome to this charming 3-bedroom, 2 1/2-bath home in the heart of Hanover, NH! Perfectly situated within walking distance to both downtown and Dartmouth College, this property offers the best of convenience and comfort. As you enter, you'll immediately appreciate the spacious and inviting atmosphere, highlighted by a large family room that's perfect for gatherings or relaxation. The living room features a cozy fireplace, creating a warm, welcoming space during the colder months. Natural light flows throughout the home, enhancing the open, airy feel. The second-floor laundry adds convenience to your daily routine. Each of the three bedrooms is generously sized, providing a peaceful retreat at the end of the day. Another room on the ground floor is great as an office or guest space. Enjoy the serenity of a screened-in porch, ideal for enjoying your morning coffee or unwinding after a busy day. The property is also close to trails, offering endless opportunities for outdoor activities, from hiking to biking, just steps from your door. The attached 2 car garage has direct access to a big mudroom and part of the full basement could be finished if you want even more space. This home offers the perfect blend of modern amenities, including central air conditioning, prime location, and outdoor access. Don’t miss your chance to experience all that Hanover has to offer – schedule your tour today!
Description:Beautifully designed and meticulously crafted contemporary cape in a private country setting. Bright sunshine fills this home adding to the atmosphere of complete comfort. Large family room is open to the excellent kitchen, there is a formal dining room with more built-ins and a gorgeous vaulted ceiling living room with fireplace. Cozy sunroom completes the first floor. Upstairs there's a gracious primary suite with balcony, 2 more bedroom, a quiet study and a convenient laundry room. The grounds are fantastic with mature gardens which can be enjoyed from the spacious covered front porch, deck off the kitchen or the stone patio. A wonderful Post and Beam barn is perfect for a workshop, antique car storage or studio space. A very special offering! Showings begin Wednesday, March 12th.
Description:A beautiful and unique piece of property just a 10 minute drive to downtown Lebanon! Located on 26 acres at the top of Eastman Hill, this property provides plenty of space, privacy and spectacular views from everywhere in the house! Recent renovations, updates and fresh paint make it move-in ready!
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.